CREATE TABLE CRST_FND_SECURITY_PROFILE (
  SECURITY_PROFILE_ID           NUMBER (15), 
BUSINESS_GROUP_ID             NUMBER (15) ,
POSITION_ID                   NUMBER (15) ,
ORGANIZATION_ID               NUMBER (15) ,
POSITION_STRUCTURE_ID         NUMBER (15) ,
ORGANIZATION_STRUCTURE_ID     NUMBER (15) ,
INCLUDE_TOP_ORGANIZATION_FLAG VARCHAR (30) ,
INCLUDE_TOP_POSITION_FLAG     VARCHAR (30) ,
SECURITY_PROFILE_NAME         VARCHAR (240) ,
VIEW_ALL_APPLICANTS_FLAG      VARCHAR (30) ,
VIEW_ALL_EMPLOYEES_FLAG       VARCHAR (30) ,
VIEW_ALL_FLAG                 VARCHAR (30) ,
VIEW_ALL_ORGANIZATIONS_FLAG   VARCHAR (30) ,
VIEW_ALL_PAYROLLS_FLAG        VARCHAR (30) ,
VIEW_ALL_POSITIONS_FLAG       VARCHAR (30) ,
INCLUDE_EXCLUDE_PAYROLL_FLAG  VARCHAR (30) ,
REPORTING_ORACLE_USERNAME     VARCHAR (30) ,
REQUEST_ID                    NUMBER (15) ,
PROGRAM_APPLICATION_ID        NUMBER (15) ,
PROGRAM_ID                    NUMBER (15) ,
PROGRAM_UPDATE_DATE           DATE ,
LAST_UPDATE_DATE              DATE ,
LAST_UPDATED_BY               NUMBER (15) ,
LAST_UPDATE_LOGIN             NUMBER (15) ,
CREATED_BY                    NUMBER (15) ,
CREATION_DATE                 DATE ,
ALLOW_GRANTED_USERS_FLAG      VARCHAR (30) ,
RESTRICT_BY_SUPERVISOR_FLAG   VARCHAR (30) ,
SUPERVISOR_LEVELS             NUMBER,
EXCLUDE_SECONDARY_ASGS_FLAG   VARCHAR (30) ,
EXCLUDE_PERSON_FLAG           VARCHAR (30) ,
NAMED_PERSON_ID               NUMBER (10) ,
CUSTOM_RESTRICTION_FLAG       VARCHAR (30) ,
RESTRICTION_TEXT              VARCHAR (4000), 
EXCLUDE_BUSINESS_GROUPS_FLAG  VARCHAR (30) ,
ORG_SECURITY_MODE             VARCHAR (30) ,
VIEW_ALL_CWK_FLAG             VARCHAR (30) ,
VIEW_ALL_CONTACTS_FLAG        VARCHAR (30) ,
  SECURITY_PROFILE_ID_N		  NUMBER (15)
);
